Dataset info
| Number of variables | 34 |
|---|---|
| Number of observations | 119389 |
| Missing cells | 129424 (3.2%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 100.8 MiB |
| Average record size in memory | 885.7 B |
Variables types
| NUM | 19 |
|---|---|
| CAT | 12 |
| BOOL | 2 |
| DATE | 1 |
Reproduction info
| Date of analysis | 2020-04-21 19:18:33.212627 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
adr has 1959 (1.6%) zeros | Zeros |
agent has 16340 (13.7%) missing values | Missing |
babies is highly skewed (γ1 = 24.64644163) | Skewed |
babies has 118472 (99.2%) zeros | Zeros |
booking_changes has 101314 (84.9%) zeros | Zeros |
children has 110795 (92.8%) zeros | Zeros |
company has 112592 (94.3%) missing values | Missing |
country has a high cardinality: 178 distinct values | Warning |
day_of_week has 18692 (15.7%) zeros | Zeros |
days_in_waiting_list has 115691 (96.9%) zeros | Zeros |
lead_time has 6345 (5.3%) zeros | Zeros |
previous_bookings_not_canceled is highly skewed (γ1 = 23.53970156) | Skewed |
previous_bookings_not_canceled has 115769 (97.0%) zeros | Zeros |
previous_cancellations is highly skewed (γ1 = 24.45794698) | Skewed |
previous_cancellations has 112905 (94.6%) zeros | Zeros |
required_car_parking_spaces has 111973 (93.8%) zeros | Zeros |
stays_in_week_nights has 7645 (6.4%) zeros | Zeros |
stays_in_weekend_nights has 51997 (43.6%) zeros | Zeros |
total_of_special_requests has 70317 (58.9%) zeros | Zeros |
| Distinct count | 8878 |
|---|---|
| Unique (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.78674417241118 |
|---|---|
| Minimum | -6.38 |
| Maximum | 510.0 |
| Zeros | 1959 |
| Zeros (%) | 1.6% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 38.4 |
| Q1 | 69.29 |
| median | 94.56 |
| Q3 | 126 |
| 95-th percentile | 193.5 |
| Maximum | 510 |
| Range | 516.38 |
| Interquartile range (IQR) | 56.71 |
Descriptive statistics
| Standard deviation | 48.15355432 |
|---|---|
| Coefficient of variation (CV) | 0.4730827645 |
| Kurtosis | 2.131745226 |
| Mean | 101.7867442 |
| Median Absolute Deviation (MAD) | 36.32946907 |
| Skewness | 1.017731447 |
| Sum | 12152217.6 |
| Variance | 2318.764794 |
| Value | Count | Frequency (%) | |
| 62 | 3754 | 3.1% | |
| 75 | 2715 | 2.3% | |
| 90 | 2473 | 2.1% | |
| 65 | 2418 | 2.0% | |
| 0 | 1959 | 1.6% | |
| 80 | 1889 | 1.6% | |
| 95 | 1661 | 1.4% | |
| 120 | 1607 | 1.3% | |
| 100 | 1573 | 1.3% | |
| 85 | 1538 | 1.3% | |
| Other values (8868) | 97802 | 81.9% |
| Value | Count | Frequency (%) | |
| -6.38 | 1 | < 0.1% | |
| 0 | 1959 | 1.6% | |
| 0.26 | 1 | < 0.1% | |
| 0.5 | 1 | < 0.1% | |
| 1 | 15 | < 0.1% |
| Value | Count | Frequency (%) | |
| 510 | 1 | < 0.1% | |
| 508 | 1 | < 0.1% | |
| 451.5 | 1 | < 0.1% | |
| 450 | 1 | < 0.1% | |
| 437 | 1 | < 0.1% |
adults
Real number (ℝ≥0)
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.856402181105462 |
|---|---|
| Minimum | 0 |
| Maximum | 55 |
| Zeros | 403 |
| Zeros (%) | 0.3% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5792632757 |
|---|---|
| Coefficient of variation (CV) | 0.3120354423 |
| Kurtosis | 1352.105314 |
| Mean | 1.856402181 |
| Median Absolute Deviation (MAD) | 0.3428875877 |
| Skewness | 18.31774829 |
| Sum | 221634 |
| Variance | 0.3355459426 |
| Value | Count | Frequency (%) | |
| 2 | 89679 | 75.1% | |
| 1 | 23027 | 19.3% | |
| 3 | 6202 | 5.2% | |
| 0 | 403 | 0.3% | |
| 4 | 62 | 0.1% | |
| 26 | 5 | < 0.1% | |
| 27 | 2 | < 0.1% | |
| 20 | 2 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| Other values (4) | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 403 | 0.3% | |
| 1 | 23027 | 19.3% | |
| 2 | 89679 | 75.1% | |
| 3 | 6202 | 5.2% | |
| 4 | 62 | 0.1% |
| Value | Count | Frequency (%) | |
| 55 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 27 | 2 | < 0.1% | |
| 26 | 5 | < 0.1% |
| Distinct count | 334 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 16340 |
| Missing (%) | 13.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 86.69410668711002 |
|---|---|
| Minimum | 1.0 |
| Maximum | 535.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 14 |
| Q3 | 229 |
| 95-th percentile | 250 |
| Maximum | 535 |
| Range | 534 |
| Interquartile range (IQR) | 220 |
Descriptive statistics
| Standard deviation | 110.7748408 |
|---|---|
| Coefficient of variation (CV) | 1.277766679 |
| Kurtosis | -0.007212717535 |
| Mean | 86.69410669 |
| Median Absolute Deviation (MAD) | 97.04704534 |
| Skewness | 1.089370905 |
| Sum | 8933741 |
| Variance | 12271.06534 |
| Value | Count | Frequency (%) | |
| 9 | 31961 | 26.8% | |
| 240 | 13922 | 11.7% | |
| 1 | 7191 | 6.0% | |
| 14 | 3640 | 3.0% | |
| 7 | 3539 | 3.0% | |
| 6 | 3290 | 2.8% | |
| 250 | 2870 | 2.4% | |
| 241 | 1721 | 1.4% | |
| 28 | 1666 | 1.4% | |
| 8 | 1514 | 1.3% | |
| Other values (323) | 31735 | 26.6% | |
| (Missing) | 16340 | 13.7% |
| Value | Count | Frequency (%) | |
| 1 | 7191 | 6.0% | |
| 2 | 162 | 0.1% | |
| 3 | 1336 | 1.1% | |
| 4 | 47 | < 0.1% | |
| 5 | 330 | 0.3% |
| Value | Count | Frequency (%) | |
| 535 | 3 | < 0.1% | |
| 531 | 68 | 0.1% | |
| 527 | 35 | < 0.1% | |
| 526 | 10 | < 0.1% | |
| 510 | 2 | < 0.1% |
arrival_date_day_of_month
Real number (ℝ≥0)
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.798163984956737 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.78082586 |
|---|---|
| Coefficient of variation (CV) | 0.5558130596 |
| Kurtosis | -1.187160324 |
| Mean | 15.79816398 |
| Median Absolute Deviation (MAD) | 7.578551325 |
| Skewness | -0.001983779709 |
| Sum | 1886127 |
| Variance | 77.10290278 |
| Value | Count | Frequency (%) | |
| 17 | 4406 | 3.7% | |
| 5 | 4317 | 3.6% | |
| 15 | 4196 | 3.5% | |
| 25 | 4159 | 3.5% | |
| 26 | 4147 | 3.5% | |
| 9 | 4096 | 3.4% | |
| 12 | 4087 | 3.4% | |
| 16 | 4078 | 3.4% | |
| 2 | 4055 | 3.4% | |
| 19 | 4052 | 3.4% | |
| Other values (21) | 77796 | 65.2% |
| Value | Count | Frequency (%) | |
| 1 | 3626 | 3.0% | |
| 2 | 4055 | 3.4% | |
| 3 | 3855 | 3.2% | |
| 4 | 3763 | 3.2% | |
| 5 | 4317 | 3.6% |
| Value | Count | Frequency (%) | |
| 31 | 2208 | 1.8% | |
| 30 | 3853 | 3.2% | |
| 29 | 3580 | 3.0% | |
| 28 | 3946 | 3.3% | |
| 27 | 3802 | 3.2% |
arrival_date_month
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| August | |
|---|---|
| July | |
| May | |
| October | 11160 |
| April | 11089 |
| Other values (7) |
| Value | Count | Frequency (%) | |
| August | 13877 | 11.6% | |
| July | 12661 | 10.6% | |
| May | 11791 | 9.9% | |
| October | 11160 | 9.3% | |
| April | 11089 | 9.3% | |
| June | 10939 | 9.2% | |
| September | 10508 | 8.8% | |
| March | 9793 | 8.2% | |
| February | 8068 | 6.8% | |
| November | 6794 | 5.7% | |
| Other values (2) | 12709 | 10.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 9 |
|---|---|
| Mean length | 5.903190411 |
| Min length | 3 |
arrival_date_week_number
Real number (ℝ≥0)
| Distinct count | 53 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.165291609779796 |
|---|---|
| Minimum | 1 |
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.60513357 |
|---|---|
| Coefficient of variation (CV) | 0.5008278123 |
| Kurtosis | -0.9860669654 |
| Mean | 27.16529161 |
| Median Absolute Deviation (MAD) | 11.5499026 |
| Skewness | -0.0100311295 |
| Sum | 3243237 |
| Variance | 185.0996594 |
| Value | Count | Frequency (%) | |
| 33 | 3580 | 3.0% | |
| 30 | 3087 | 2.6% | |
| 32 | 3045 | 2.6% | |
| 34 | 3040 | 2.5% | |
| 18 | 2926 | 2.5% | |
| 21 | 2854 | 2.4% | |
| 28 | 2853 | 2.4% | |
| 17 | 2805 | 2.3% | |
| 20 | 2785 | 2.3% | |
| 29 | 2763 | 2.3% | |
| Other values (43) | 89651 | 75.1% |
| Value | Count | Frequency (%) | |
| 1 | 1047 | 0.9% | |
| 2 | 1218 | 1.0% | |
| 3 | 1319 | 1.1% | |
| 4 | 1487 | 1.2% | |
| 5 | 1387 | 1.2% |
| Value | Count | Frequency (%) | |
| 53 | 1816 | 1.5% | |
| 52 | 1195 | 1.0% | |
| 51 | 933 | 0.8% | |
| 50 | 1505 | 1.3% | |
| 49 | 1782 | 1.5% |
arrival_date_year
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
| Value | Count | Frequency (%) | |
| 2016 | 56706 | 47.5% | |
| 2017 | 40687 | 34.1% | |
| 2015 | 21996 | 18.4% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
assigned_room_type
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| A | |
|---|---|
| D | |
| E | 7806 |
| F | 3751 |
| G | 2553 |
| Other values (7) | 5905 |
| Value | Count | Frequency (%) | |
| A | 74052 | 62.0% | |
| D | 25322 | 21.2% | |
| E | 7806 | 6.5% | |
| F | 3751 | 3.1% | |
| G | 2553 | 2.1% | |
| C | 2375 | 2.0% | |
| B | 2163 | 1.8% | |
| H | 712 | 0.6% | |
| I | 363 | 0.3% | |
| K | 279 | 0.2% | |
| Other values (2) | 13 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.007948806003903207 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 118472 |
| Zeros (%) | 99.2% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.09743659665 |
|---|---|
| Coefficient of variation (CV) | 12.25801669 |
| Kurtosis | 1633.934639 |
| Mean | 0.007948806004 |
| Median Absolute Deviation (MAD) | 0.01577550603 |
| Skewness | 24.64644163 |
| Sum | 949 |
| Variance | 0.009493890367 |
| Value | Count | Frequency (%) | |
| 0 | 118472 | 99.2% | |
| 1 | 900 | 0.8% | |
| 2 | 15 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 118472 | 99.2% | |
| 1 | 900 | 0.8% | |
| 2 | 15 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 2 | 15 | < 0.1% | |
| 1 | 900 | 0.8% | |
| 0 | 118472 | 99.2% |
| Distinct count | 21 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.22111752338992705 |
|---|---|
| Minimum | 0 |
| Maximum | 21 |
| Zeros | 101314 |
| Zeros (%) | 84.9% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6523044096 |
|---|---|
| Coefficient of variation (CV) | 2.950034894 |
| Kurtosis | 79.3951055 |
| Mean | 0.2211175234 |
| Median Absolute Deviation (MAD) | 0.3752824928 |
| Skewness | 6.000368154 |
| Sum | 26399 |
| Variance | 0.4255010428 |
| Value | Count | Frequency (%) | |
| 0 | 101314 | 84.9% | |
| 1 | 12700 | 10.6% | |
| 2 | 3805 | 3.2% | |
| 3 | 927 | 0.8% | |
| 4 | 376 | 0.3% | |
| 5 | 118 | 0.1% | |
| 6 | 63 | 0.1% | |
| 7 | 31 | < 0.1% | |
| 8 | 17 | < 0.1% | |
| 9 | 8 | < 0.1% | |
| Other values (11) | 30 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 101314 | 84.9% | |
| 1 | 12700 | 10.6% | |
| 2 | 3805 | 3.2% | |
| 3 | 927 | 0.8% | |
| 4 | 376 | 0.3% |
| Value | Count | Frequency (%) | |
| 21 | 1 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 17 | 2 | < 0.1% | |
| 16 | 2 | < 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10389077354776563 |
|---|---|
| Minimum | 0.0 |
| Maximum | 10.0 |
| Zeros | 110795 |
| Zeros (%) | 92.8% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3985630006 |
|---|---|
| Coefficient of variation (CV) | 3.836365704 |
| Kurtosis | 18.67349954 |
| Mean | 0.1038907735 |
| Median Absolute Deviation (MAD) | 0.192831231 |
| Skewness | 4.112569428 |
| Sum | 12403 |
| Variance | 0.1588524655 |
| Value | Count | Frequency (%) | |
| 0 | 110795 | 92.8% | |
| 1 | 4861 | 4.1% | |
| 2 | 3652 | 3.1% | |
| 3 | 76 | 0.1% | |
| 10 | 1 | < 0.1% | |
| (Missing) | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 110795 | 92.8% | |
| 1 | 4861 | 4.1% | |
| 2 | 3652 | 3.1% | |
| 3 | 76 | 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 3 | 76 | 0.1% | |
| 2 | 3652 | 3.1% | |
| 1 | 4861 | 4.1% | |
| 0 | 110795 | 92.8% |
| Distinct count | 353 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 112592 |
| Missing (%) | 94.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 189.26673532440782 |
|---|---|
| Minimum | 6.0 |
| Maximum | 543.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 62 |
| median | 179 |
| Q3 | 270 |
| 95-th percentile | 435 |
| Maximum | 543 |
| Range | 537 |
| Interquartile range (IQR) | 208 |
Descriptive statistics
| Standard deviation | 131.6550146 |
|---|---|
| Coefficient of variation (CV) | 0.6956056721 |
| Kurtosis | -0.4907952103 |
| Mean | 189.2667353 |
| Median Absolute Deviation (MAD) | 109.1110502 |
| Skewness | 0.6015996673 |
| Sum | 1286446 |
| Variance | 17333.04288 |
| Value | Count | Frequency (%) | |
| 40 | 927 | 0.8% | |
| 223 | 784 | 0.7% | |
| 67 | 267 | 0.2% | |
| 45 | 250 | 0.2% | |
| 153 | 215 | 0.2% | |
| 174 | 149 | 0.1% | |
| 219 | 141 | 0.1% | |
| 281 | 138 | 0.1% | |
| 154 | 133 | 0.1% | |
| 405 | 119 | 0.1% | |
| Other values (342) | 3674 | 3.1% | |
| (Missing) | 112592 | 94.3% |
| Value | Count | Frequency (%) | |
| 6 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 37 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 543 | 2 | < 0.1% | |
| 541 | 1 | < 0.1% | |
| 539 | 2 | < 0.1% | |
| 534 | 2 | < 0.1% | |
| 531 | 1 | < 0.1% |
| Distinct count | 178 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 488 |
| Missing (%) | 0.4% |
| Memory size | 932.8 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | 8568 |
| DEU | 7287 |
| Other values (172) |
| Value | Count | Frequency (%) | |
| PRT | 48589 | 40.7% | |
| GBR | 12129 | 10.2% | |
| FRA | 10415 | 8.7% | |
| ESP | 8568 | 7.2% | |
| DEU | 7287 | 6.1% | |
| ITA | 3766 | 3.2% | |
| IRL | 3375 | 2.8% | |
| BEL | 2342 | 2.0% | |
| BRA | 2224 | 1.9% | |
| NLD | 2104 | 1.8% | |
| Other values (167) | 18102 | 15.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 3 |
|---|---|
| Mean length | 2.98928712 |
| Min length | 2 |
customer_type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 4076 |
| Group | 577 |
| Value | Count | Frequency (%) | |
| Transient | 89612 | 75.1% | |
| Transient-Party | 25124 | 21.0% | |
| Contract | 4076 | 3.4% | |
| Group | 577 | 0.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 15 |
|---|---|
| Mean length | 10.20915662 |
| Min length | 5 |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.885257435777165 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 18692 |
| Zeros (%) | 15.7% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.984294259 |
|---|---|
| Coefficient of variation (CV) | 0.6877356019 |
| Kurtosis | -1.186485604 |
| Mean | 2.885257436 |
| Median Absolute Deviation (MAD) | 1.69793948 |
| Skewness | 0.0777885192 |
| Sum | 344468 |
| Variance | 3.937423708 |
| Value | Count | Frequency (%) | |
| 0 | 18692 | 15.7% | |
| 4 | 18470 | 15.5% | |
| 3 | 18141 | 15.2% | |
| 2 | 17943 | 15.0% | |
| 1 | 16731 | 14.0% | |
| 6 | 16488 | 13.8% | |
| 5 | 12924 | 10.8% |
| Value | Count | Frequency (%) | |
| 0 | 18692 | 15.7% | |
| 1 | 16731 | 14.0% | |
| 2 | 17943 | 15.0% | |
| 3 | 18141 | 15.2% | |
| 4 | 18470 | 15.5% |
| Value | Count | Frequency (%) | |
| 6 | 16488 | 13.8% | |
| 5 | 12924 | 10.8% | |
| 4 | 18470 | 15.5% | |
| 3 | 18141 | 15.2% | |
| 2 | 17943 | 15.0% |
| Distinct count | 128 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3211686168742514 |
|---|---|
| Minimum | 0 |
| Maximum | 391 |
| Zeros | 115691 |
| Zeros (%) | 96.9% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 17.59479328 |
|---|---|
| Coefficient of variation (CV) | 7.580144396 |
| Kurtosis | 186.7914825 |
| Mean | 2.321168617 |
| Median Absolute Deviation (MAD) | 4.498836213 |
| Skewness | 11.94430274 |
| Sum | 277122 |
| Variance | 309.5767507 |
| Value | Count | Frequency (%) | |
| 0 | 115691 | 96.9% | |
| 39 | 227 | 0.2% | |
| 58 | 164 | 0.1% | |
| 44 | 141 | 0.1% | |
| 31 | 127 | 0.1% | |
| 35 | 96 | 0.1% | |
| 46 | 94 | 0.1% | |
| 69 | 89 | 0.1% | |
| 63 | 83 | 0.1% | |
| 50 | 80 | 0.1% | |
| Other values (118) | 2597 | 2.2% |
| Value | Count | Frequency (%) | |
| 0 | 115691 | 96.9% | |
| 1 | 12 | < 0.1% | |
| 2 | 5 | < 0.1% | |
| 3 | 59 | < 0.1% | |
| 4 | 25 | < 0.1% |
| Value | Count | Frequency (%) | |
| 391 | 45 | < 0.1% | |
| 379 | 15 | < 0.1% | |
| 330 | 15 | < 0.1% | |
| 259 | 10 | < 0.1% | |
| 236 | 35 | < 0.1% |
deposit_type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| No Deposit | |
|---|---|
| Non Refund | 14586 |
| Refundable | 162 |
| Value | Count | Frequency (%) | |
| No Deposit | 104641 | 87.6% | |
| Non Refund | 14586 | 12.2% | |
| Refundable | 162 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 119389 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59694.59363928 |
|---|---|
| Minimum | 0 |
| Maximum | 119389 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5969.4 |
| Q1 | 29847 |
| median | 59695 |
| Q3 | 89542 |
| 95-th percentile | 113419.6 |
| Maximum | 119389 |
| Range | 119389 |
| Interquartile range (IQR) | 59695 |
Descriptive statistics
| Standard deviation | 34465.19781 |
|---|---|
| Coefficient of variation (CV) | 0.5773587809 |
| Kurtosis | -1.200011997 |
| Mean | 59694.59364 |
| Median Absolute Deviation (MAD) | 29847.65636 |
| Skewness | -7.865032929e-06 |
| Sum | 7126877840 |
| Variance | 1187849860 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 19747 | 1 | < 0.1% | |
| 118035 | 1 | < 0.1% | |
| 103704 | 1 | < 0.1% | |
| 105753 | 1 | < 0.1% | |
| 99610 | 1 | < 0.1% | |
| 101659 | 1 | < 0.1% | |
| 111900 | 1 | < 0.1% | |
| 113949 | 1 | < 0.1% | |
| 107806 | 1 | < 0.1% | |
| Other values (119379) | 119379 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 119389 | 1 | < 0.1% | |
| 119388 | 1 | < 0.1% | |
| 119387 | 1 | < 0.1% | |
| 119386 | 1 | < 0.1% | |
| 119385 | 1 | < 0.1% |
distribution_channel
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| TA/TO | |
|---|---|
| Direct | 14645 |
| Corporate | 6677 |
| GDS | 193 |
| Undefined | 5 |
| Value | Count | Frequency (%) | |
| TA/TO | 97869 | 82.0% | |
| Direct | 14645 | 12.3% | |
| Corporate | 6677 | 5.6% | |
| GDS | 193 | 0.2% | |
| Undefined | 5 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 9 |
|---|---|
| Mean length | 5.343306335 |
| Min length | 3 |
hotel
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
| Value | Count | Frequency (%) | |
| City Hotel | 79329 | 66.4% | |
| Resort Hotel | 40060 | 33.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 12 |
|---|---|
| Mean length | 10.6710836 |
| Min length | 10 |
is_canceled
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 75166 | 63.0% | |
| 1 | 44223 | 37.0% |
is_repeated_guest
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| 0 | |
|---|---|
| 1 | 3810 |
| Value | Count | Frequency (%) | |
| 0 | 115579 | 96.8% | |
| 1 | 3810 | 3.2% |
| Distinct count | 479 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104.01199440484467 |
|---|---|
| Minimum | 0 |
| Maximum | 737 |
| Zeros | 6345 |
| Zeros (%) | 5.3% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 18 |
| median | 69 |
| Q3 | 160 |
| 95-th percentile | 320 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 142 |
Descriptive statistics
| Standard deviation | 106.8633579 |
|---|---|
| Coefficient of variation (CV) | 1.027413795 |
| Kurtosis | 1.696411731 |
| Mean | 104.0119944 |
| Median Absolute Deviation (MAD) | 84.67224136 |
| Skewness | 1.346537317 |
| Sum | 12417888 |
| Variance | 11419.77727 |
| Value | Count | Frequency (%) | |
| 0 | 6345 | 5.3% | |
| 1 | 3460 | 2.9% | |
| 2 | 2069 | 1.7% | |
| 3 | 1816 | 1.5% | |
| 4 | 1715 | 1.4% | |
| 5 | 1565 | 1.3% | |
| 6 | 1445 | 1.2% | |
| 7 | 1331 | 1.1% | |
| 8 | 1138 | 1.0% | |
| 12 | 1079 | 0.9% | |
| Other values (469) | 97426 | 81.6% |
| Value | Count | Frequency (%) | |
| 0 | 6345 | 5.3% | |
| 1 | 3460 | 2.9% | |
| 2 | 2069 | 1.7% | |
| 3 | 1816 | 1.5% | |
| 4 | 1715 | 1.4% |
| Value | Count | Frequency (%) | |
| 737 | 1 | < 0.1% | |
| 709 | 1 | < 0.1% | |
| 629 | 17 | < 0.1% | |
| 626 | 30 | < 0.1% | |
| 622 | 17 | < 0.1% |
market_segment
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 5295 |
| Other values (3) | 982 |
| Value | Count | Frequency (%) | |
| Online TA | 56477 | 47.3% | |
| Offline TA/TO | 24218 | 20.3% | |
| Groups | 19811 | 16.6% | |
| Direct | 12606 | 10.6% | |
| Corporate | 5295 | 4.4% | |
| Complementary | 743 | 0.6% | |
| Aviation | 237 | 0.2% | |
| Undefined | 2 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 13 |
|---|---|
| Mean length | 9.019733811 |
| Min length | 6 |
meal
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| BB | |
|---|---|
| HB | 14463 |
| SC | 10650 |
| Undefined | 1169 |
| FB | 798 |
| Value | Count | Frequency (%) | |
| BB | 92309 | 77.3% | |
| HB | 14463 | 12.1% | |
| SC | 10650 | 8.9% | |
| Undefined | 1169 | 1.0% | |
| FB | 798 | 0.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 9 |
|---|---|
| Mean length | 2.068540653 |
| Min length | 2 |
| Distinct count | 73 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13709805760999758 |
|---|---|
| Minimum | 0 |
| Maximum | 72 |
| Zeros | 115769 |
| Zeros (%) | 97.0% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.497443066 |
|---|---|
| Coefficient of variation (CV) | 10.92242365 |
| Kurtosis | 767.2387944 |
| Mean | 0.1370980576 |
| Median Absolute Deviation (MAD) | 0.2658822007 |
| Skewness | 23.53970156 |
| Sum | 16368 |
| Variance | 2.242335737 |
| Value | Count | Frequency (%) | |
| 0 | 115769 | 97.0% | |
| 1 | 1542 | 1.3% | |
| 2 | 580 | 0.5% | |
| 3 | 333 | 0.3% | |
| 4 | 229 | 0.2% | |
| 5 | 181 | 0.2% | |
| 6 | 115 | 0.1% | |
| 7 | 88 | 0.1% | |
| 8 | 70 | 0.1% | |
| 9 | 60 | 0.1% | |
| Other values (63) | 422 | 0.4% |
| Value | Count | Frequency (%) | |
| 0 | 115769 | 97.0% | |
| 1 | 1542 | 1.3% | |
| 2 | 580 | 0.5% | |
| 3 | 333 | 0.3% | |
| 4 | 229 | 0.2% |
| Value | Count | Frequency (%) | |
| 72 | 1 | < 0.1% | |
| 71 | 1 | < 0.1% | |
| 70 | 1 | < 0.1% | |
| 69 | 1 | < 0.1% | |
| 68 | 1 | < 0.1% |
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08711857876353768 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros | 112905 |
| Zeros (%) | 94.6% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8443398826 |
|---|---|
| Coefficient of variation (CV) | 9.691846384 |
| Kurtosis | 674.0680579 |
| Mean | 0.08711857876 |
| Median Absolute Deviation (MAD) | 0.1647743617 |
| Skewness | 24.45794698 |
| Sum | 10401 |
| Variance | 0.7129098374 |
| Value | Count | Frequency (%) | |
| 0 | 112905 | 94.6% | |
| 1 | 6051 | 5.1% | |
| 2 | 116 | 0.1% | |
| 3 | 65 | 0.1% | |
| 24 | 48 | < 0.1% | |
| 11 | 35 | < 0.1% | |
| 4 | 31 | < 0.1% | |
| 26 | 26 | < 0.1% | |
| 25 | 25 | < 0.1% | |
| 6 | 22 | < 0.1% | |
| Other values (5) | 65 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 112905 | 94.6% | |
| 1 | 6051 | 5.1% | |
| 2 | 116 | 0.1% | |
| 3 | 65 | 0.1% | |
| 4 | 31 | < 0.1% |
| Value | Count | Frequency (%) | |
| 26 | 26 | < 0.1% | |
| 25 | 25 | < 0.1% | |
| 24 | 48 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 19 | 19 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06251832245851795 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros | 111973 |
| Zeros (%) | 93.8% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.245292108 |
|---|---|
| Coefficient of variation (CV) | 3.923523511 |
| Kurtosis | 29.99778011 |
| Mean | 0.06251832246 |
| Median Absolute Deviation (MAD) | 0.1172698343 |
| Skewness | 4.163212935 |
| Sum | 7464 |
| Variance | 0.06016821826 |
| Value | Count | Frequency (%) | |
| 0 | 111973 | 93.8% | |
| 1 | 7383 | 6.2% | |
| 2 | 28 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 111973 | 93.8% | |
| 1 | 7383 | 6.2% | |
| 2 | 28 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 2 | 28 | < 0.1% | |
| 1 | 7383 | 6.2% | |
| 0 | 111973 | 93.8% |
reservation_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 1207 |
| Value | Count | Frequency (%) | |
| Check-Out | 75166 | 63.0% | |
| Canceled | 43016 | 36.0% | |
| No-Show | 1207 | 1.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 9 |
|---|---|
| Mean length | 8.619479181 |
| Min length | 7 |
| Distinct count | 926 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| Minimum | 2014-10-17 00:00:00 |
|---|---|
| Maximum | 2017-09-14 00:00:00 |
reserved_room_type
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.8 KiB |
| A | |
|---|---|
| D | |
| E | 6535 |
| F | 2897 |
| G | 2094 |
| Other values (5) | 2669 |
| Value | Count | Frequency (%) | |
| A | 85993 | 72.0% | |
| D | 19201 | 16.1% | |
| E | 6535 | 5.5% | |
| F | 2897 | 2.4% | |
| G | 2094 | 1.8% | |
| B | 1118 | 0.9% | |
| C | 932 | 0.8% | |
| H | 601 | 0.5% | |
| P | 12 | < 0.1% | |
| L | 6 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5003140992888793 |
|---|---|
| Minimum | 0 |
| Maximum | 50 |
| Zeros | 7645 |
| Zeros (%) | 6.4% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.908288667 |
|---|---|
| Coefficient of variation (CV) | 0.7632195761 |
| Kurtosis | 24.28453022 |
| Mean | 2.500314099 |
| Median Absolute Deviation (MAD) | 1.364288191 |
| Skewness | 2.862243798 |
| Sum | 298510 |
| Variance | 3.641565637 |
| Value | Count | Frequency (%) | |
| 2 | 33684 | 28.2% | |
| 1 | 30309 | 25.4% | |
| 3 | 22258 | 18.6% | |
| 5 | 11077 | 9.3% | |
| 4 | 9563 | 8.0% | |
| 0 | 7645 | 6.4% | |
| 6 | 1499 | 1.3% | |
| 10 | 1036 | 0.9% | |
| 7 | 1029 | 0.9% | |
| 8 | 656 | 0.5% | |
| Other values (25) | 633 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 7645 | 6.4% | |
| 1 | 30309 | 25.4% | |
| 2 | 33684 | 28.2% | |
| 3 | 22258 | 18.6% | |
| 4 | 9563 | 8.0% |
| Value | Count | Frequency (%) | |
| 50 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 40 | 2 | < 0.1% | |
| 35 | 1 | < 0.1% |
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9276063958991196 |
|---|---|
| Minimum | 0 |
| Maximum | 19 |
| Zeros | 51997 |
| Zeros (%) | 43.6% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.9986140682 |
|---|---|
| Coefficient of variation (CV) | 1.076549356 |
| Kurtosis | 7.174078723 |
| Mean | 0.9276063959 |
| Median Absolute Deviation (MAD) | 0.8079931948 |
| Skewness | 1.380039003 |
| Sum | 110746 |
| Variance | 0.9972300573 |
| Value | Count | Frequency (%) | |
| 0 | 51997 | 43.6% | |
| 2 | 33308 | 27.9% | |
| 1 | 30626 | 25.7% | |
| 4 | 1855 | 1.6% | |
| 3 | 1259 | 1.1% | |
| 6 | 153 | 0.1% | |
| 5 | 79 | 0.1% | |
| 8 | 60 | 0.1% | |
| 7 | 19 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| Other values (7) | 22 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 51997 | 43.6% | |
| 1 | 30626 | 25.7% | |
| 2 | 33308 | 27.9% | |
| 3 | 1259 | 1.1% | |
| 4 | 1855 | 1.6% |
| Value | Count | Frequency (%) | |
| 19 | 1 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 16 | 3 | < 0.1% | |
| 14 | 2 | < 0.1% | |
| 13 | 3 | < 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5713675464238749 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 70317 |
| Zeros (%) | 58.9% |
| Memory size | 932.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7928000185 |
|---|---|
| Coefficient of variation (CV) | 1.387548214 |
| Kurtosis | 1.492531434 |
| Mean | 0.5713675464 |
| Median Absolute Deviation (MAD) | 0.673041097 |
| Skewness | 1.349177557 |
| Sum | 68215 |
| Variance | 0.6285318694 |
| Value | Count | Frequency (%) | |
| 0 | 70317 | 58.9% | |
| 1 | 33226 | 27.8% | |
| 2 | 12969 | 10.9% | |
| 3 | 2497 | 2.1% | |
| 4 | 340 | 0.3% | |
| 5 | 40 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 70317 | 58.9% | |
| 1 | 33226 | 27.8% | |
| 2 | 12969 | 10.9% | |
| 3 | 2497 | 2.1% | |
| 4 | 340 | 0.3% |
| Value | Count | Frequency (%) | |
| 5 | 40 | < 0.1% | |
| 4 | 340 | 0.3% | |
| 3 | 2497 | 2.1% | |
| 2 | 12969 | 10.9% | |
| 1 | 33226 | 27.8% |
First rows
| adr | adults | agent | arrival_date_day_of_month | arrival_date_month | arrival_date_week_number | arrival_date_year | assigned_room_type | babies | booking_changes | children | company | country | customer_type | day_of_week | days_in_waiting_list | deposit_type | df_index | distribution_channel | hotel | is_canceled | is_repeated_guest | lead_time | market_segment | meal | previous_bookings_not_canceled | previous_cancellations | required_car_parking_spaces | reservation_status | reservation_status_date | reserved_room_type | stays_in_week_nights | stays_in_weekend_nights | total_of_special_requests | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.0 | 2 | NaN | 1 | July | 27 | 2015 | C | 0 | 3 | 0.0 | NaN | PRT | Transient | 2 | 0 | No Deposit | 0 | Direct | Resort Hotel | 0 | 0 | 342 | Direct | BB | 0 | 0 | 0 | Check-Out | 2015-07-01 | C | 0 | 0 | 0 |
| 1 | 0.0 | 2 | NaN | 1 | July | 27 | 2015 | C | 0 | 4 | 0.0 | NaN | PRT | Transient | 2 | 0 | No Deposit | 1 | Direct | Resort Hotel | 0 | 0 | 737 | Direct | BB | 0 | 0 | 0 | Check-Out | 2015-07-01 | C | 0 | 0 | 0 |
| 2 | 75.0 | 1 | NaN | 1 | July | 27 | 2015 | C | 0 | 0 | 0.0 | NaN | GBR | Transient | 3 | 0 | No Deposit | 2 | Direct | Resort Hotel | 0 | 0 | 7 | Direct | BB | 0 | 0 | 0 | Check-Out | 2015-07-02 | A | 1 | 0 | 0 |
| 3 | 75.0 | 1 | 304.0 | 1 | July | 27 | 2015 | A | 0 | 0 | 0.0 | NaN | GBR | Transient | 3 | 0 | No Deposit | 3 | Corporate | Resort Hotel | 0 | 0 | 13 | Corporate | BB | 0 | 0 | 0 | Check-Out | 2015-07-02 | A | 1 | 0 | 0 |
| 4 | 98.0 | 2 | 240.0 | 1 | July | 27 | 2015 | A | 0 | 0 | 0.0 | NaN | GBR | Transient | 4 | 0 | No Deposit | 4 | TA/TO | Resort Hotel | 0 | 0 | 14 | Online TA | BB | 0 | 0 | 0 | Check-Out | 2015-07-03 | A | 2 | 0 | 1 |
| 5 | 98.0 | 2 | 240.0 | 1 | July | 27 | 2015 | A | 0 | 0 | 0.0 | NaN | GBR | Transient | 4 | 0 | No Deposit | 5 | TA/TO | Resort Hotel | 0 | 0 | 14 | Online TA | BB | 0 | 0 | 0 | Check-Out | 2015-07-03 | A | 2 | 0 | 1 |
| 6 | 107.0 | 2 | NaN | 1 | July | 27 | 2015 | C | 0 | 0 | 0.0 | NaN | PRT | Transient | 4 | 0 | No Deposit | 6 | Direct | Resort Hotel | 0 | 0 | 0 | Direct | BB | 0 | 0 | 0 | Check-Out | 2015-07-03 | C | 2 | 0 | 0 |
| 7 | 103.0 | 2 | 303.0 | 1 | July | 27 | 2015 | C | 0 | 0 | 0.0 | NaN | PRT | Transient | 4 | 0 | No Deposit | 7 | Direct | Resort Hotel | 0 | 0 | 9 | Direct | FB | 0 | 0 | 0 | Check-Out | 2015-07-03 | C | 2 | 0 | 1 |
| 8 | 82.0 | 2 | 240.0 | 1 | July | 27 | 2015 | A | 0 | 0 | 0.0 | NaN | PRT | Transient | 2 | 0 | No Deposit | 8 | TA/TO | Resort Hotel | 1 | 0 | 85 | Online TA | BB | 0 | 0 | 0 | Canceled | 2015-05-06 | A | 3 | 0 | 1 |
| 9 | 105.5 | 2 | 15.0 | 1 | July | 27 | 2015 | D | 0 | 0 | 0.0 | NaN | PRT | Transient | 2 | 0 | No Deposit | 9 | TA/TO | Resort Hotel | 1 | 0 | 75 | Offline TA/TO | HB | 0 | 0 | 0 | Canceled | 2015-04-22 | D | 3 | 0 | 0 |
Last rows
| adr | adults | agent | arrival_date_day_of_month | arrival_date_month | arrival_date_week_number | arrival_date_year | assigned_room_type | babies | booking_changes | children | company | country | customer_type | day_of_week | days_in_waiting_list | deposit_type | df_index | distribution_channel | hotel | is_canceled | is_repeated_guest | lead_time | market_segment | meal | previous_bookings_not_canceled | previous_cancellations | required_car_parking_spaces | reservation_status | reservation_status_date | reserved_room_type | stays_in_week_nights | stays_in_weekend_nights | total_of_special_requests | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119379 | 140.75 | 2 | 9.0 | 31 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | DEU | Transient | 0 | 0 | No Deposit | 119380 | TA/TO | City Hotel | 0 | 0 | 44 | Online TA | SC | 0 | 0 | 0 | Check-Out | 2017-09-04 | A | 3 | 1 | 1 |
| 119380 | 99.00 | 2 | 14.0 | 31 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | DEU | Transient | 1 | 0 | No Deposit | 119381 | Direct | City Hotel | 0 | 0 | 188 | Direct | BB | 0 | 0 | 0 | Check-Out | 2017-09-05 | A | 3 | 2 | 0 |
| 119381 | 209.00 | 3 | 7.0 | 30 | August | 35 | 2017 | G | 0 | 0 | 0.0 | NaN | JPN | Transient | 1 | 0 | No Deposit | 119382 | TA/TO | City Hotel | 0 | 0 | 135 | Online TA | BB | 0 | 0 | 0 | Check-Out | 2017-09-05 | G | 4 | 2 | 0 |
| 119382 | 87.60 | 2 | 42.0 | 31 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | DEU | Transient | 2 | 0 | No Deposit | 119383 | TA/TO | City Hotel | 0 | 0 | 164 | Offline TA/TO | BB | 0 | 0 | 0 | Check-Out | 2017-09-06 | A | 4 | 2 | 0 |
| 119383 | 96.14 | 2 | 394.0 | 30 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | BEL | Transient | 2 | 0 | No Deposit | 119384 | TA/TO | City Hotel | 0 | 0 | 21 | Offline TA/TO | BB | 0 | 0 | 0 | Check-Out | 2017-09-06 | A | 5 | 2 | 2 |
| 119384 | 96.14 | 2 | 394.0 | 30 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | BEL | Transient | 2 | 0 | No Deposit | 119385 | TA/TO | City Hotel | 0 | 0 | 23 | Offline TA/TO | BB | 0 | 0 | 0 | Check-Out | 2017-09-06 | A | 5 | 2 | 0 |
| 119385 | 225.43 | 3 | 9.0 | 31 | August | 35 | 2017 | E | 0 | 0 | 0.0 | NaN | FRA | Transient | 3 | 0 | No Deposit | 119386 | TA/TO | City Hotel | 0 | 0 | 102 | Online TA | BB | 0 | 0 | 0 | Check-Out | 2017-09-07 | E | 5 | 2 | 2 |
| 119386 | 157.71 | 2 | 9.0 | 31 | August | 35 | 2017 | D | 0 | 0 | 0.0 | NaN | DEU | Transient | 3 | 0 | No Deposit | 119387 | TA/TO | City Hotel | 0 | 0 | 34 | Online TA | BB | 0 | 0 | 0 | Check-Out | 2017-09-07 | D | 5 | 2 | 4 |
| 119387 | 104.40 | 2 | 89.0 | 31 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | GBR | Transient | 3 | 0 | No Deposit | 119388 | TA/TO | City Hotel | 0 | 0 | 109 | Online TA | BB | 0 | 0 | 0 | Check-Out | 2017-09-07 | A | 5 | 2 | 0 |
| 119388 | 151.20 | 2 | 9.0 | 29 | August | 35 | 2017 | A | 0 | 0 | 0.0 | NaN | DEU | Transient | 3 | 0 | No Deposit | 119389 | TA/TO | City Hotel | 0 | 0 | 205 | Online TA | HB | 0 | 0 | 0 | Check-Out | 2017-09-07 | A | 7 | 2 | 2 |